Entity DefinitionLogical Name : RetailStoreCustomer |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | RetailStore(PA_STR_RTL) |
| CustomerID (FK)(PK) | A unique system assigned identifier for the Customer. | ID_CT | Identity | integer | Customer(PA_CT) |
| ClienteleID | An alternate ID assigned to a clienteling customer. | ID_CLNT_RTL | Identity | integer |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| Customer | has used | RetailStoreCustomer |
| RetailStore | has clients of | RetailStoreCustomer |
| Logical View |
|---|
| Logical 07010 - Customer Account Information Extended |